Appendix 3: Affected tables
For a list of tables and other technical components, screens, objects, functions, and so on, used for electronic invoicing, you can use the Activity code search utility (RECHACT) and perform a search on the EINV and SN activity codes.
The following tables have been extracted from the results of running this utility on the EINV activity code.
Table updates
|
Table |
Description |
Field |
Description |
|---|---|---|---|
|
BPARTNER |
Business partner |
INTSRVCOD |
Service code |
|
RTGCOD |
Routing code |
||
|
EINVTYP |
e-invoice type |
||
|
MAPCOD |
e-invoice mapping code |
||
|
ELCADD |
Electronic address code |
||
|
SUFFIX |
Suffix |
||
|
MAILEINV |
Email address |
||
|
BPCUSTOMERXT |
Customer |
INTSRVCOD |
Service code |
|
RTGCOD |
Routing code |
||
|
EINVTYP |
e-invoice type |
||
|
MAPCOD |
e-invoice mapping code |
||
|
ELCADD |
Electronic address code |
||
|
SUFFIX |
Suffix |
||
|
MAILEINV |
Email address |
||
|
BPEXCEPT |
Company exception |
EINVTYP |
e-invoice mapping code |
|
MAPCODBPC |
Electronic address code |
||
|
BPSUPPLIER |
Supplier |
INVORIMOD |
Default module |
|
COMPANY |
Company |
SERVICEID |
ID service |
|
FACILITY |
Site |
RTGCOD |
Routing code |
|
ELCADD |
Electronic address code |
||
|
INTSERVCOD |
C Service code |
||
|
MAILEINV |
Email address |
||
|
SUFFIX |
Suffix |
||
|
SFOOTINV |
Invoicing elements |
DISCRGREACOD |
Charge Reason code |
|
SORDER |
Sale order – Header |
ADLREF |
Complementary reference |
|
TABPAM |
Payment method |
PAYMETTYP |
Payment type Code |
|
TABPIVTYP |
Supplier invoice type |
EINVTYP1 |
Invoice type code |
|
EINVTYP2 |
Factoring invoice type code |
||
|
TABSIVTYP |
Customer invoice type |
EINVTYP1
|
Invoice type code |
|
EINVTYP2 |
Factoring invoice type code |
||
|
TABVAT |
Tax code |
VATCAT |
Tax category |
|
EXEVATREACOD |
Exoneration reason code |
||
|
DISCRGREACOD |
Charge reason code |
||
|
VSORDER |
Sales Order history - Header |
ADLREF |
Complementary reference |
Tables created
|
Table |
Description |
Activity code |
|---|---|---|
|
EINVMAP |
Mapping |
|
|
EINVMAPD |
Mapping details |
|
|
EINVMAPXSD |
XSD |
|
|
EINVMON |
Monitoring |
SN |
|
EINVOUT |
Customer e- invoice |
|
|
EINVSTA |
Life cycle |
EINV |
|
EINVWK |
e- invoice working table (header) |
EINAP |
|
EINVWKD |
e- invoice working table (lines) |
EINAP |
|
ESINVD |
e-invoice line snapshot |
EINV |
|
ESINVH |
e-invoice line snapshot |
EINV |
|
ESINVHSFI |
e-invoice invoicing elements snapshot |
EINV |
|
ESINVHVAT |
e-invoice tax recapitulative snapshot |
EINV |
|
ESINVNOT |
e-invoice notes snapshot |
EINV |
|
ESINVTRDPTY |
e-invoice business partner snapshot |
EINV |
|
SNAPINVING |
AP automation – invoice ingestion |
SNAP |
|
SNINBVING |
AP automation – invoice received |
EINV |